Extract substring from left to a specific character for each row in a pandas dataframe